﻿CREATE PROCEDURE [dbo].[proc_Customer_CallOnTongJi_CategoryViewCount]
	(
		@DepartmentId int,
		@StartDate nvarchar(10),
		@EndDate nvarchar(10)
	)
AS
	Select Count(Id) From Customer_Track ct
	Where ct.DepartmentId=@DepartmentId and Convert(nchar(10),UpTime,120)>=@StartDate and Convert(nchar(10),UpTime,120)<=@EndDate and ct.PublicityDemandId <>0 and NetworkConsciousnessId<>0
	RETURN
